<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@include file="../WEB-INF/jspf/controlesessao.jspf"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Lista Competencias_Docentes</title>
        <script type="text/javascript" src="../js/jquery.js" ></script>
        <script type="text/javascript" src="../js/jquery.validate.js"></script>
        <script type="text/javascript" src="../js/jquery.tablescroll.js"></script>
        <script type="text/javascript" src="../js/forms.js"></script>
        <script type="text/javascript" src="../js/jquery-ui-1.8.2.custom.min.js" ></script>
        <link rel="stylesheet" href="../css/ui-lightness/jquery-ui-1.8.2.custom.css">
    <link rel="stylesheet" href="../css/forms.css"></head>

    <body>

            <form action="fm_new_Competencias_Docentes.jsp">
                <input type="hidden" name="matricula" value="${param.matricula}">
                <input type="submit" id="novo" value="Novo"/>
            <input type="hidden" id="token" name="token" value="${sessionScope.token}" /> </form>
            <br>
            <sql:query var="query" dataSource="jdbc/dbo_MicrosoftSQLServer">
                SELECT d.matricula, c.*,prazo,inicio,
                    case
                        when prioridade=1 then 'Baixa'
                        when prioridade=2 then 'Média'
                        when prioridade=3 then 'Alta'
                     end prioridade
                FROM Competencias_Docentes d
                inner join competencias c on d.id_competencia=c.id_competencia
                where matricula=?
                <sql:param value="${param.matricula}"/>
            </sql:query>
            <table cellspacing="0">
                <thead>
                    <th>Competência</th>
                    <th>Início</th>
                    <th>Prazo</th>
                    <th>Prioridade</th>
                </thead>
                <tbody>
                    <c:forEach var="row" items="${query.rows}">
                        <fmt:formatDate value="${row.prazo}" var="prazo" pattern="dd/MM/yyyy"/>
                        <fmt:formatDate value="${row.inicio}" var="inicio" pattern="dd/MM/yyyy"/>
                        <tr><td><a href="fm_update_Competencias_Docentes.jsp?token=${sessionScope.token}&id_competencia=${row.id_competencia}&matricula=${row.matricula}">${row.desc_competencia}</a></td>
                            <td>${inicio}</td>
                            <td>${prazo}</td>
                            <td>${row.prioridade}</td>
                        </tr>
                    </c:forEach>
                </tbody>
            </table>
      
        <script>
            jQuery(document).ready(function($)
            {
                $('table').tableScroll({height:300});

            });
        </script>
    </body>
</html>
